﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="js.aspx.cs" Inherits="student_js" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <div style="background-image: url('/bookWEB/images/NFLDfog_ZH-CN4846953507_1920x1080.jpg'); width: auto; height: 1000px;">

    <form id="form1" runat="server">
    <p>
        您好：<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
&nbsp; 日期：<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
    </p>
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource2" Height="192px" 
            Width="531px" BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" 
            BorderWidth="1px" CellPadding="3" CellSpacing="2">
            <Columns>
                <asp:BoundField DataField="ReadersID" HeaderText="学号" 
                    SortExpression="ID" />
                <asp:BoundField DataField="BI_BID" HeaderText="书号" 
                    SortExpression="bookid" />
                <asp:BoundField DataField="BARB_BDATE" HeaderText="借书日期" 
                    SortExpression="borrowdatatime" />
                <asp:BoundField DataField="BI_TITLE" HeaderText="书名" 
                    SortExpression="bookname" />
                <asp:BoundField DataField="ReadersNAME" HeaderText="借阅人" 
                    SortExpression="js_name" />
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#FFF1D4" />
            <SortedAscendingHeaderStyle BackColor="#B95C30" />
            <SortedDescendingCellStyle BackColor="#F1E5CE" />
            <SortedDescendingHeaderStyle BackColor="#93451F" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:tsmanagerConnectionString %>" 
            SelectCommand="SELECT * FROM [JS] WHERE ([ReadersID] = @ReadersID) ORDER BY [BARB_BDATE]">
            <SelectParameters>
                <asp:SessionParameter Name="ReadersID" SessionField="id" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:tsmanagerConnectionString %>" 
            SelectCommand="SELECT * FROM [JS]">
        </asp:SqlDataSource>
        <br />
        <asp:Button ID="Button1" runat="server" onclick="Button1_Click1" Text="还书" 
            style="height: 21px" />
        <br />
    </div>
    </form>
</body>
</html>
